ALTER TABLE IONWaveformCheckpoint
ADD LogPositions VARCHAR(MAX) NOT NULL DEFAULT '[]'

ALTER TABLE IONWaveformCheckpoint
ADD CONSTRAINT IX_IONWaveformCheckpoint_Device UNIQUE (Device ASC, TimeRecorded ASC)

ALTER TABLE IONTrendingCheckpoint
ADD LogPositions VARCHAR(MAX) NOT NULL DEFAULT '[]'

ALTER TABLE IONTrendingCheckpoint
ADD CONSTRAINT IX_IONTrendingCheckpoint_Device UNIQUE (Device ASC, TimeRecorded ASC)